﻿Create PROCEDURE [dbo].[proc_UserRoles_GetList]

AS
	;WITH list As(Select ROW_NUMBER() OVER (ORDER BY UserId) AS Row,
		[Id]
      ,[UserId]
      ,[RoleId]
	From [aspnet_UsersInRoles] --Where (@CompanyId=0 Or CompanyId=@CompanyId) And (@Stext IS NULL Or [Name] like '%'+@Stext+'%')
	)
	
	Select * From list --Where Row between @StartIndex and @EndIndex
	RETURN
